<!--#include file="lib/utf-8.asp"-->
<!--#include file="lib/conn.asp"-->
<%
 sql="select id,tyr,yb_freight,freight_id,freight_name from yb left join  freight on yb.tyr=freight.freight_name"
		Set rs = Server.CreateObject("ADODB.Recordset")
	rs.open sql,conn,2,2
 do while not rs.eof

	rs("yb_freight")=rs("freight_id")
 rs.movenext
 loop
%>